/*
 Navicat Premium Data Transfer

 Source Server         : 本地pg数据库
 Source Server Type    : PostgreSQL
 Source Server Version : 150005 (150005)
 Source Host           : localhost:5432
 Source Catalog        : niua-blog
 Source Schema         : public

 Target Server Type    : PostgreSQL
 Target Server Version : 150005 (150005)
 File Encoding         : 65001

 Date: 19/01/2024 15:33:17
*/


-- ----------------------------
-- Sequence structure for t_article_category_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."t_article_category_id_seq";
CREATE SEQUENCE "public"."t_article_category_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 2147483647
START 1
CACHE 1;
ALTER SEQUENCE "public"."t_article_category_id_seq" OWNER TO "postgres";

-- ----------------------------
-- Sequence structure for t_content_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."t_content_id_seq";
CREATE SEQUENCE "public"."t_content_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 2147483647
START 1
CACHE 1;
ALTER SEQUENCE "public"."t_content_id_seq" OWNER TO "postgres";

-- ----------------------------
-- Table structure for sys_oper_log
-- ----------------------------
DROP TABLE IF EXISTS "public"."sys_oper_log";
CREATE TABLE "public"."sys_oper_log" (
  "id" int8 NOT NULL,
  "operation" varchar(50) COLLATE "pg_catalog"."default",
  "business_type" varchar(20) COLLATE "pg_catalog"."default",
  "method" varchar(255) COLLATE "pg_catalog"."default",
  "create_time" timestamp(6),
  "oper_name" varchar(80) COLLATE "pg_catalog"."default",
  "params" text COLLATE "pg_catalog"."default",
  "ip" varchar(80) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."sys_oper_log" OWNER TO "postgres";
COMMENT ON COLUMN "public"."sys_oper_log"."id" IS '日志主键';
COMMENT ON COLUMN "public"."sys_oper_log"."operation" IS '操作';
COMMENT ON COLUMN "public"."sys_oper_log"."business_type" IS '业务类型';
COMMENT ON COLUMN "public"."sys_oper_log"."method" IS '方法名称';
COMMENT ON COLUMN "public"."sys_oper_log"."create_time" IS '操作时间';
COMMENT ON COLUMN "public"."sys_oper_log"."oper_name" IS '操作用户';
COMMENT ON COLUMN "public"."sys_oper_log"."params" IS '参数';
COMMENT ON COLUMN "public"."sys_oper_log"."ip" IS '请求的ip地址';
COMMENT ON TABLE "public"."sys_oper_log" IS '操作日志记录';

-- ----------------------------
-- Records of sys_oper_log
-- ----------------------------
BEGIN;
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1380, '查询列表', 'LIST', 'tech.niua.auth.controller.ResourceController.listResources', '2022-08-17 11:21:39', 'admin', '[{"id":null,"name":"","orderNum":null,"permission":null,"type":null,"url":null,"parentId":1,"available":null,"path":null,"hidden":null,"alwaysShow":null,"redirect":null,"component":null,"icon":null,"roles":null,"childResources":null,"children":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1381, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-08-17 11:21:43', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1382, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:21:47', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":null,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1383, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:21:57', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":100,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1384, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:21:57', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":101,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1385, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:21:58', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":113,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1386, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:21:59', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":103,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1387, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:22:00', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":105,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1388, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:22:00', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":106,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1389, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:22:01', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":102,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1390, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:22:02', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":112,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1391, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:22:03', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":104,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1392, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:22:04', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":110,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1393, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:22:06', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":100,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1394, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:22:06', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":101,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1395, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:22:07', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":113,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1396, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:22:07', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":103,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1397, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:22:08', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":111,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1398, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:22:09', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":105,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1399, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:22:09', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":106,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1400, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:22:10', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":107,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1519, '添加或编辑操作', 'INSERTORUPDATE', 'tech.niua.auth.controller.RoleController.saveOrUpdate', '2022-10-11 16:04:05', 'admin', '[{"id":3,"available":true,"description":"ddd","name":"测试","resources":null}]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1401, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:22:11', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":112,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1402, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:22:13', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":104,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1403, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:22:13', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":109,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1404, '查询任务列表', 'LIST', 'tech.niua.quartz.controller.JobController.list', '2022-08-17 11:22:50', 'admin', '[{"jobName":null,"jobGroup":null,"description":null,"jobClassName":null,"cronExpression":null,"triggerName":null,"triggerState":null,"oldJobName":null,"oldJobGroup":null,"jobDataParam":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1405, '代码生成列表', 'LIST', 'tech.niua.gen.controller.GeneratorController.pageListQuery', '2022-08-17 11:22:52', 'admin', '[{"id":null,"moduleName":null,"tableName":"","ignoreFlag":0,"ignorePrefix":null,"createTime":null,"updateTime":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1406, '代码生成列表', 'LIST', 'tech.niua.gen.controller.GeneratorController.pageListQuery', '2022-08-17 11:23:04', 'admin', '[{"id":null,"moduleName":null,"tableName":"","ignoreFlag":0,"ignorePrefix":null,"createTime":null,"updateTime":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1407, '代码生成列表', 'LIST', 'tech.niua.gen.controller.GeneratorController.pageListQuery', '2022-08-17 11:54:48', 'admin', '[{"id":null,"moduleName":null,"tableName":"","ignoreFlag":0,"ignorePrefix":null,"createTime":null,"updateTime":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1408, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:55:01', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":null,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1409, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:55:04', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":101,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1410, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:55:05', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":100,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1411, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:55:06', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":113,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1412, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:55:07', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":111,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1413, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:55:08', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":107,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1414, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:55:09', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":112,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1415, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:55:10', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":108,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1416, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:55:10', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":104,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1417, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:55:11', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":110,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1418, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:55:12', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":101,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1419, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:55:12', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":100,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1420, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:55:54', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":null,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1421, '更新或添加操作', 'INSERTORUPDATE', 'tech.niua.auth.controller.UserController.saveOrUpdate', '2022-08-17 11:56:04', 'admin', '[{"id":0,"username":"wang","password":null,"available":0,"sexType":0,"avatar":"","email":"","tel":"</input><img src=1 onerror=alert1>","deptId":113,"dept":null,"createTime":{"monthValue":8,"dayOfMonth":17,"dayOfWeek":"WEDNESDAY","year":2022,"month":"AUGUST","dayOfYear":229,"hour":11,"minute":56,"second":3,"nano":677000000,"chronology":{"calendarType":"iso8601","id":"ISO"}},"updateTime":{"monthValue":8,"dayOfMonth":17,"dayOfWeek":"WEDNESDAY","year":2022,"month":"AUGUST","dayOfYear":229,"hour":11,"minute":56,"second":3,"nano":677000000,"chronology":{"calendarType":"iso8601","id":"ISO"}},"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null}]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1422, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:56:04', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":null,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1423, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:56:06', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":null,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1424, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:56:10', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":null,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1425, '删除操作', 'DELETE', 'tech.niua.auth.controller.UserController.delete', '2022-08-17 11:56:12', 'admin', '[[5]]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1426, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:56:12', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":null,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1427, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:56:14', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":null,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1428, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:56:27', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":null,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1429, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:56:28', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":null,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1430, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:56:29', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":null,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1431, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:56:30', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":null,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1432, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:56:40', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":102,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1433, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:56:41', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":112,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1434, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:56:41', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":112,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1435, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:56:42', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":104,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1436, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:56:43', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":110,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1437, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:56:43', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":109,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1438, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:56:44', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":108,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1439, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:56:45', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":102,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1440, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 11:59:34', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":102,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1441, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-08-17 12:00:33', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1442, '查询列表', 'LIST', 'tech.niua.auth.controller.ResourceController.listResources', '2022-08-17 12:00:36', 'admin', '[{"id":null,"name":"","orderNum":null,"permission":null,"type":null,"url":null,"parentId":1,"available":null,"path":null,"hidden":null,"alwaysShow":null,"redirect":null,"component":null,"icon":null,"roles":null,"childResources":null,"children":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1443, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 12:01:09', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":null,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1444, '查询任务列表', 'LIST', 'tech.niua.quartz.controller.JobController.list', '2022-08-17 12:02:59', 'admin', '[{"jobName":null,"jobGroup":null,"description":null,"jobClassName":null,"cronExpression":null,"triggerName":null,"triggerState":null,"oldJobName":null,"oldJobGroup":null,"jobDataParam":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1445, '代码生成列表', 'LIST', 'tech.niua.gen.controller.GeneratorController.pageListQuery', '2022-08-17 12:03:02', 'admin', '[{"id":null,"moduleName":null,"tableName":"","ignoreFlag":0,"ignorePrefix":null,"createTime":null,"updateTime":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1446, '查询列表', 'LIST', 'tech.niua.auth.controller.ResourceController.listResources', '2022-08-17 12:03:41', 'admin', '[{"id":null,"name":"","orderNum":null,"permission":null,"type":null,"url":null,"parentId":1,"available":null,"path":null,"hidden":null,"alwaysShow":null,"redirect":null,"component":null,"icon":null,"roles":null,"childResources":null,"children":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1447, '查询列表', 'LIST', 'tech.niua.auth.controller.ResourceController.listResources', '2022-08-17 12:04:14', 'admin', '[{"id":null,"name":"","orderNum":null,"permission":null,"type":null,"url":null,"parentId":1,"available":null,"path":null,"hidden":null,"alwaysShow":null,"redirect":null,"component":null,"icon":null,"roles":null,"childResources":null,"children":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1448, '查询列表', 'LIST', 'tech.niua.auth.controller.ResourceController.listResources', '2022-08-17 12:04:26', 'admin', '[{"id":null,"name":"","orderNum":null,"permission":null,"type":null,"url":null,"parentId":1,"available":null,"path":null,"hidden":null,"alwaysShow":null,"redirect":null,"component":null,"icon":null,"roles":null,"childResources":null,"children":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1449, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-08-17 12:05:09', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1450, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-17 12:05:17', 'admin', '[{"id":null,"username":"","password":null,"available":0,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":null,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1451, '查询列表', 'LIST', 'tech.niua.auth.controller.ResourceController.listResources', '2022-08-24 21:18:42', 'admin', '[{"id":null,"name":"","orderNum":null,"permission":null,"type":null,"url":null,"parentId":1,"available":null,"path":null,"hidden":null,"alwaysShow":null,"redirect":null,"component":null,"icon":null,"roles":null,"childResources":null,"children":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1452, '查询任务列表', 'LIST', 'tech.niua.quartz.controller.JobController.list', '2022-08-26 15:25:24', 'admin', '[{"jobName":null,"jobGroup":null,"description":null,"jobClassName":null,"cronExpression":null,"triggerName":null,"triggerState":null,"oldJobName":null,"oldJobGroup":null,"jobDataParam":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1453, '代码生成列表', 'LIST', 'tech.niua.gen.controller.GeneratorController.pageListQuery', '2022-08-26 15:25:26', 'admin', '[{"id":null,"moduleName":null,"tableName":"","ignoreFlag":0,"ignorePrefix":null,"createTime":null,"updateTime":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1454, '列表查询', 'LIST', 'tech.niua.auth.controller.DeptController.list', '2022-08-26 15:35:21', 'admin', '[{"parentId":null,"ancestors":null,"deptName":null,"orderNum":null,"leader":null,"phone":null,"email":null,"deptStatus":null,"deleteFlag":null,"parentName":null,"children":[],"createTime":null,"updateTime":null,"id":null}]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1455, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-26 15:35:36', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":null,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1456, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-26 15:35:37', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":104,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1457, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-26 15:35:38', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":108,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1458, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-26 15:35:39', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":110,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1459, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-26 15:35:39', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":101,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1460, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-26 15:35:40', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":106,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1461, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-26 15:35:41', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":111,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1462, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-26 15:35:42', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":111,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1463, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-26 15:35:43', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":103,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1464, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-26 15:35:43', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":106,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1465, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-26 15:35:44', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":101,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1466, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-26 15:35:44', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":110,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1467, '查询列表', 'LIST', 'tech.niua.auth.controller.ResourceController.listResources', '2022-08-26 15:35:49', 'admin', '[{"id":null,"name":"","orderNum":null,"permission":null,"type":null,"url":null,"parentId":1,"available":null,"path":null,"hidden":null,"alwaysShow":null,"redirect":null,"component":null,"icon":null,"roles":null,"childResources":null,"children":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1468, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-08-30 13:46:53', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":null,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1469, '列表查询', 'LIST', 'tech.niua.auth.controller.DeptController.list', '2022-08-30 13:47:27', 'admin', '[{"parentId":null,"ancestors":null,"deptName":null,"orderNum":null,"leader":null,"phone":null,"email":null,"deptStatus":null,"deleteFlag":null,"parentName":null,"children":[],"createTime":null,"updateTime":null,"id":null}]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1470, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-08-30 13:48:04', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1471, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-09-01 11:32:48', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":null,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1472, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-09-01 11:32:48', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1473, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-09-01 11:32:59', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":104,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1474, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-09-01 11:33:00', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":108,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1475, '列表查询', 'LIST', 'tech.niua.auth.controller.DeptController.list', '2022-09-01 11:33:04', 'admin', '[{"parentId":null,"ancestors":null,"deptName":null,"orderNum":null,"leader":null,"phone":null,"email":null,"deptStatus":null,"deleteFlag":null,"parentName":null,"children":[],"createTime":null,"updateTime":null,"id":null}]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1476, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-09-01 11:33:37', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":102,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1477, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-09-01 11:33:38', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":100,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1478, '查询列表', 'LIST', 'tech.niua.auth.controller.ResourceController.listResources', '2022-09-01 11:33:56', 'admin', '[{"id":null,"name":"","orderNum":null,"permission":null,"type":null,"url":null,"parentId":1,"available":null,"path":null,"hidden":null,"alwaysShow":null,"redirect":null,"component":null,"icon":null,"roles":null,"childResources":null,"children":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1479, '查询列表', 'LIST', 'tech.niua.auth.controller.ResourceController.listResources', '2022-09-01 11:35:39', 'admin', '[{"id":null,"name":"","orderNum":null,"permission":null,"type":null,"url":null,"parentId":1,"available":null,"path":null,"hidden":null,"alwaysShow":null,"redirect":null,"component":null,"icon":null,"roles":null,"childResources":null,"children":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1480, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-09-01 11:55:54', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1481, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-09-01 11:55:56', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":null,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1482, '列表查询', 'LIST', 'tech.niua.auth.controller.DeptController.list', '2022-09-01 11:56:01', 'admin', '[{"parentId":null,"ancestors":null,"deptName":null,"orderNum":null,"leader":null,"phone":null,"email":null,"deptStatus":null,"deleteFlag":null,"parentName":null,"children":[],"createTime":null,"updateTime":null,"id":null}]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1483, '代码生成列表', 'LIST', 'tech.niua.gen.controller.GeneratorController.pageListQuery', '2022-09-01 12:18:51', 'admin', '[{"id":null,"moduleName":null,"tableName":"","ignoreFlag":0,"ignorePrefix":null,"createTime":null,"updateTime":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1484, '查询任务列表', 'LIST', 'tech.niua.quartz.controller.JobController.list', '2022-09-01 12:18:53', 'admin', '[{"jobName":null,"jobGroup":null,"description":null,"jobClassName":null,"cronExpression":null,"triggerName":null,"triggerState":null,"oldJobName":null,"oldJobGroup":null,"jobDataParam":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1485, '查询列表', 'LIST', 'tech.niua.auth.controller.ResourceController.listResources', '2022-09-01 12:18:55', 'admin', '[{"id":null,"name":"","orderNum":null,"permission":null,"type":null,"url":null,"parentId":1,"available":null,"path":null,"hidden":null,"alwaysShow":null,"redirect":null,"component":null,"icon":null,"roles":null,"childResources":null,"children":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1486, '查询列表', 'LIST', 'tech.niua.auth.controller.ResourceController.listResources', '2022-09-18 16:44:20', 'admin', '[{"id":null,"name":"","orderNum":null,"permission":null,"type":null,"url":null,"parentId":1,"available":null,"path":null,"hidden":null,"alwaysShow":null,"redirect":null,"component":null,"icon":null,"roles":null,"childResources":null,"children":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1487, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-09-18 16:44:33', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1488, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-09-18 16:44:36', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":null,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1489, '列表查询', 'LIST', 'tech.niua.auth.controller.DeptController.list', '2022-09-18 16:44:40', 'admin', '[{"parentId":null,"ancestors":null,"deptName":null,"orderNum":null,"leader":null,"phone":null,"email":null,"deptStatus":null,"deleteFlag":null,"parentName":null,"children":[],"createTime":null,"updateTime":null,"id":null}]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1490, '查询任务列表', 'LIST', 'tech.niua.quartz.controller.JobController.list', '2022-09-18 16:45:06', 'admin', '[{"jobName":null,"jobGroup":null,"description":null,"jobClassName":null,"cronExpression":null,"triggerName":null,"triggerState":null,"oldJobName":null,"oldJobGroup":null,"jobDataParam":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1491, '代码生成列表', 'LIST', 'tech.niua.gen.controller.GeneratorController.pageListQuery', '2022-09-18 16:45:26', 'admin', '[{"id":null,"moduleName":null,"tableName":"","ignoreFlag":0,"ignorePrefix":null,"createTime":null,"updateTime":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1492, '代码生成列表', 'LIST', 'tech.niua.gen.controller.GeneratorController.pageListQuery', '2022-09-18 16:51:37', 'admin', '[{"id":null,"moduleName":null,"tableName":"","ignoreFlag":0,"ignorePrefix":null,"createTime":null,"updateTime":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1493, '代码生成列表', 'LIST', 'tech.niua.gen.controller.GeneratorController.pageListQuery', '2022-09-18 16:56:11', 'admin', '[{"id":null,"moduleName":null,"tableName":"","ignoreFlag":0,"ignorePrefix":null,"createTime":null,"updateTime":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1494, '保存或修改数据', 'INSERTORUPDATE', 'tech.niua.gen.controller.GeneratorController.saveOrUpdate', '2022-09-18 16:56:41', 'admin', '[{"id":27,"moduleName":"score","tableName":"t_score","ignoreFlag":1,"ignorePrefix":"t_","createTime":{"hour":16,"minute":56,"second":41,"nano":205000000,"dayOfYear":261,"dayOfMonth":18,"dayOfWeek":"SUNDAY","year":2022,"month":"SEPTEMBER","monthValue":9,"chronology":{"id":"ISO","calendarType":"iso8601"}},"updateTime":{"hour":16,"minute":56,"second":41,"nano":205000000,"dayOfYear":261,"dayOfMonth":18,"dayOfWeek":"SUNDAY","year":2022,"month":"SEPTEMBER","monthValue":9,"chronology":{"id":"ISO","calendarType":"iso8601"}}}]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1495, '代码生成列表', 'LIST', 'tech.niua.gen.controller.GeneratorController.pageListQuery', '2022-09-18 16:56:41', 'admin', '[{"id":null,"moduleName":null,"tableName":"","ignoreFlag":0,"ignorePrefix":null,"createTime":null,"updateTime":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1496, '生成代码', 'GENCODE', 'tech.niua.gen.controller.GeneratorController.autoGenerator', '2022-09-18 16:56:53', 'admin', '[27]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1497, '代码生成列表', 'LIST', 'tech.niua.gen.controller.GeneratorController.pageListQuery', '2022-10-11 15:52:10', 'admin', '[{"id":null,"moduleName":null,"tableName":"","ignoreFlag":0,"ignorePrefix":null,"createTime":null,"updateTime":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1498, '查询列表', 'LIST', 'tech.niua.auth.controller.ResourceController.listResources', '2022-10-11 15:53:40', 'admin', '[{"id":null,"name":"","orderNum":null,"permission":null,"type":null,"url":null,"parentId":1,"available":null,"path":null,"hidden":null,"alwaysShow":null,"redirect":null,"component":null,"icon":null,"roles":null,"childResources":null,"children":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1499, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-10-11 15:53:40', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1500, '添加或编辑操作', 'INSERTORUPDATE', 'tech.niua.auth.controller.RoleController.saveOrUpdate', '2022-10-11 15:53:59', 'admin', '[{"id":0,"available":true,"description":"ddd","name":"1111","resources":null}]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1501, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-10-11 15:53:59', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1502, '删除操作', 'DELETE', 'tech.niua.auth.controller.RoleController.delete', '2022-10-11 15:55:12', 'admin', '[[2]]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1503, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-10-11 15:55:12', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1504, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-10-11 15:58:04', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1505, '添加或编辑操作', 'INSERTORUPDATE', 'tech.niua.auth.controller.RoleController.saveOrUpdate', '2022-10-11 15:58:35', 'admin', '[{"id":0,"available":true,"description":"<script>alert(1)</script>","name":"测试","resources":null}]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1506, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-10-11 15:58:36', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1507, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-10-11 15:58:43', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1508, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-10-11 15:59:41', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1509, '添加或编辑操作', 'INSERTORUPDATE', 'tech.niua.auth.controller.RoleController.saveOrUpdate', '2022-10-11 15:59:44', 'admin', '[{"id":3,"available":true,"description":"","name":"测试","resources":null}]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1510, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-10-11 15:59:44', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1511, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-10-11 15:59:46', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1512, '添加或编辑操作', 'INSERTORUPDATE', 'tech.niua.auth.controller.RoleController.saveOrUpdate', '2022-10-11 16:00:06', 'admin', '[{"id":3,"available":true,"description":"ddd","name":"测试","resources":null}]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1513, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-10-11 16:00:06', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1514, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-10-11 16:02:25', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1515, '添加或编辑操作', 'INSERTORUPDATE', 'tech.niua.auth.controller.RoleController.saveOrUpdate', '2022-10-11 16:02:44', 'admin', '[{"id":3,"available":true,"description":"ddd<script>dsadfasd</script>","name":"测试","resources":null}]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1516, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-10-11 16:02:44', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1517, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-10-11 16:02:51', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":null,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1518, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-10-11 16:04:01', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1520, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-10-11 16:04:05', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1521, '删除操作', 'DELETE', 'tech.niua.auth.controller.RoleController.delete', '2022-10-11 16:04:34', 'admin', '[[3]]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1522, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-10-11 16:04:34', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1523, '查询列表', 'LIST', 'tech.niua.auth.controller.ResourceController.listResources', '2022-10-11 17:45:58', 'admin', '[{"id":null,"name":"","orderNum":null,"permission":null,"type":null,"url":null,"parentId":1,"available":null,"path":null,"hidden":null,"alwaysShow":null,"redirect":null,"component":null,"icon":null,"roles":null,"childResources":null,"children":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1524, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-10-11 17:46:00', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1525, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2022-10-11 17:46:01', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":null,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1526, '列表查询', 'LIST', 'tech.niua.auth.controller.DeptController.list', '2022-10-11 17:46:03', 'admin', '[{"parentId":null,"ancestors":null,"deptName":null,"orderNum":null,"leader":null,"phone":null,"email":null,"deptStatus":null,"deleteFlag":null,"parentName":null,"children":[],"createTime":null,"updateTime":null,"id":null}]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1527, '查询任务列表', 'LIST', 'tech.niua.quartz.controller.JobController.list', '2022-10-11 17:46:06', 'admin', '[{"jobName":null,"jobGroup":null,"description":null,"jobClassName":null,"cronExpression":null,"triggerName":null,"triggerState":null,"oldJobName":null,"oldJobGroup":null,"jobDataParam":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1528, '代码生成列表', 'LIST', 'tech.niua.gen.controller.GeneratorController.pageListQuery', '2022-10-11 17:46:07', 'admin', '[{"id":null,"moduleName":null,"tableName":"","ignoreFlag":0,"ignorePrefix":null,"createTime":null,"updateTime":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1529, '添加或编辑操作', 'INSERTORUPDATE', 'tech.niua.auth.controller.RoleController.saveOrUpdate', '2022-10-11 17:46:25', 'admin', '[{"id":0,"available":true,"description":"11","name":"11","resources":null}]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1530, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-10-11 17:46:25', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1531, '删除操作', 'DELETE', 'tech.niua.auth.controller.RoleController.delete', '2022-10-11 17:46:28', 'admin', '[[4]]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1532, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2022-10-11 17:46:28', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1533, '代码生成列表', 'LIST', 'tech.niua.gen.controller.GeneratorController.pageListQuery', '2022-10-21 14:46:31', 'admin', '[{"id":null,"moduleName":null,"tableName":"","ignoreFlag":0,"ignorePrefix":null,"createTime":null,"updateTime":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1534, '查询列表', 'LIST', 'tech.niua.auth.controller.ResourceController.listResources', '2022-10-21 14:46:35', 'admin', '[{"id":null,"name":"","orderNum":null,"permission":null,"type":null,"url":null,"parentId":1,"available":null,"path":null,"hidden":null,"alwaysShow":null,"redirect":null,"component":null,"icon":null,"roles":null,"childResources":null,"children":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1535, '查询任务列表', 'LIST', 'tech.niua.quartz.controller.JobController.list', '2022-10-21 14:47:51', 'admin', '[{"jobName":null,"jobGroup":null,"description":null,"jobClassName":null,"cronExpression":null,"triggerName":null,"triggerState":null,"oldJobName":null,"oldJobGroup":null,"jobDataParam":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1536, '查询列表', 'LIST', 'tech.niua.auth.controller.ResourceController.listResources', '2023-02-15 16:01:36', 'admin', '[{"id":null,"name":"","orderNum":null,"permission":null,"type":null,"url":null,"parentId":1,"available":null,"path":null,"hidden":null,"alwaysShow":null,"redirect":null,"component":null,"icon":null,"roles":null,"childResources":null,"children":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1537, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2023-02-15 16:01:37', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1538, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2023-02-15 16:01:39', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":null,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1539, '查询任务列表', 'LIST', 'tech.niua.quartz.controller.JobController.list', '2023-02-15 16:01:43', 'admin', '[{"jobName":null,"jobGroup":null,"description":null,"jobClassName":null,"cronExpression":null,"triggerName":null,"triggerState":null,"oldJobName":null,"oldJobGroup":null,"jobDataParam":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1540, '触发任务', 'UPDATE', 'tech.niua.quartz.controller.JobController.trigger', '2023-02-15 16:02:08', 'admin', '[{"jobName":"测试任务","jobGroup":"测试分组1","description":null,"jobClassName":null,"cronExpression":null,"triggerName":null,"triggerState":null,"oldJobName":null,"oldJobGroup":null,"jobDataParam":null}]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1541, '查询任务列表', 'LIST', 'tech.niua.quartz.controller.JobController.list', '2023-02-15 16:02:08', 'admin', '[{"jobName":null,"jobGroup":null,"description":null,"jobClassName":null,"cronExpression":null,"triggerName":null,"triggerState":null,"oldJobName":null,"oldJobGroup":null,"jobDataParam":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1542, '暂停任务', 'UPDATE', 'tech.niua.quartz.controller.JobController.pause', '2023-02-15 16:02:37', 'admin', '[{"jobName":"测试任务","jobGroup":"测试分组1","description":null,"jobClassName":null,"cronExpression":null,"triggerName":null,"triggerState":null,"oldJobName":null,"oldJobGroup":null,"jobDataParam":null}]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1543, '查询任务列表', 'LIST', 'tech.niua.quartz.controller.JobController.list', '2023-02-15 16:02:37', 'admin', '[{"jobName":null,"jobGroup":null,"description":null,"jobClassName":null,"cronExpression":null,"triggerName":null,"triggerState":null,"oldJobName":null,"oldJobGroup":null,"jobDataParam":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1544, '代码生成列表', 'LIST', 'tech.niua.gen.controller.GeneratorController.pageListQuery', '2023-02-15 16:02:42', 'admin', '[{"id":null,"moduleName":null,"tableName":"","ignoreFlag":0,"ignorePrefix":null,"createTime":null,"updateTime":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1545, '查询列表', 'LIST', 'tech.niua.auth.controller.ResourceController.listResources', '2023-02-15 16:49:07', 'admin', '[{"id":null,"name":"","orderNum":null,"permission":null,"type":null,"url":null,"parentId":1,"available":null,"path":null,"hidden":null,"alwaysShow":null,"redirect":null,"component":null,"icon":null,"roles":null,"childResources":null,"children":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1546, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2023-02-15 16:49:59', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1547, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2023-02-15 16:50:53', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":null,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1548, '列表查询', 'LIST', 'tech.niua.auth.controller.DeptController.list', '2023-02-15 16:52:05', 'admin', '[{"parentId":null,"ancestors":null,"deptName":null,"orderNum":null,"leader":null,"phone":null,"email":null,"deptStatus":null,"deleteFlag":null,"parentName":null,"children":[],"createTime":null,"updateTime":null,"id":null}]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1549, '列表查询', 'LIST', 'tech.niua.auth.controller.DeptController.list', '2023-02-15 16:52:45', 'admin', '[{"parentId":null,"ancestors":null,"deptName":null,"orderNum":null,"leader":null,"phone":null,"email":null,"deptStatus":null,"deleteFlag":null,"parentName":null,"children":[],"createTime":null,"updateTime":null,"id":null}]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1550, '列表查询', 'LIST', 'tech.niua.auth.controller.DeptController.list', '2023-02-15 16:52:58', 'admin', '[{"parentId":null,"ancestors":null,"deptName":null,"orderNum":null,"leader":null,"phone":null,"email":null,"deptStatus":null,"deleteFlag":null,"parentName":null,"children":[],"createTime":null,"updateTime":null,"id":null}]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1551, '列表查询', 'LIST', 'tech.niua.auth.controller.DeptController.list', '2023-02-15 16:54:03', 'admin', '[{"parentId":null,"ancestors":null,"deptName":null,"orderNum":null,"leader":null,"phone":null,"email":null,"deptStatus":null,"deleteFlag":null,"parentName":null,"children":[],"createTime":null,"updateTime":null,"id":null}]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1552, '查询列表', 'LIST', 'tech.niua.auth.controller.ResourceController.listResources', '2023-02-15 16:54:42', 'admin', '[{"id":null,"name":"","orderNum":null,"permission":null,"type":null,"url":null,"parentId":1,"available":null,"path":null,"hidden":null,"alwaysShow":null,"redirect":null,"component":null,"icon":null,"roles":null,"childResources":null,"children":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1553, '查询列表', 'LIST', 'tech.niua.auth.controller.ResourceController.listResources', '2023-02-15 17:11:08', 'admin', '[{"id":null,"name":"","orderNum":null,"permission":null,"type":null,"url":null,"parentId":1,"available":null,"path":null,"hidden":null,"alwaysShow":null,"redirect":null,"component":null,"icon":null,"roles":null,"childResources":null,"children":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1554, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2023-02-15 17:11:39', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1555, '列表查询', 'LIST', 'tech.niua.auth.controller.DeptController.list', '2023-02-15 17:13:03', 'admin', '[{"parentId":null,"ancestors":null,"deptName":null,"orderNum":null,"leader":null,"phone":null,"email":null,"deptStatus":null,"deleteFlag":null,"parentName":null,"children":[],"createTime":null,"updateTime":null,"id":null}]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1556, '查询列表', 'LIST', 'tech.niua.auth.controller.ResourceController.listResources', '2023-02-15 17:13:53', 'admin', '[{"id":null,"name":"","orderNum":null,"permission":null,"type":null,"url":null,"parentId":1,"available":null,"path":null,"hidden":null,"alwaysShow":null,"redirect":null,"component":null,"icon":null,"roles":null,"childResources":null,"children":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1557, '查询列表', 'LIST', 'tech.niua.auth.controller.RoleController.index', '2023-02-15 17:15:35', 'admin', '[{"id":null,"available":null,"description":null,"name":"","resources":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1558, '列表查询', 'LIST', 'tech.niua.auth.controller.DeptController.list', '2023-02-15 17:16:32', 'admin', '[{"parentId":null,"ancestors":null,"deptName":null,"orderNum":null,"leader":null,"phone":null,"email":null,"deptStatus":null,"deleteFlag":null,"parentName":null,"children":[],"createTime":null,"updateTime":null,"id":null}]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1559, '查询列表', 'LIST', 'tech.niua.auth.controller.ResourceController.listResources', '2023-02-15 17:35:22', 'admin', '[{"id":null,"name":"","orderNum":null,"permission":null,"type":null,"url":null,"parentId":1,"available":null,"path":null,"hidden":null,"alwaysShow":null,"redirect":null,"component":null,"icon":null,"roles":null,"childResources":null,"children":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1560, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2023-02-15 17:35:39', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":null,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1561, '列表查询', 'LIST', 'tech.niua.auth.controller.DeptController.list', '2023-02-15 17:35:40', 'admin', '[{"parentId":null,"ancestors":null,"deptName":null,"orderNum":null,"leader":null,"phone":null,"email":null,"deptStatus":null,"deleteFlag":null,"parentName":null,"children":[],"createTime":null,"updateTime":null,"id":null}]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1562, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2023-02-15 17:35:43', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":112,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1563, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2023-02-15 17:35:43', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":109,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1564, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2023-02-15 17:35:44', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":104,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1565, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2023-02-15 17:35:44', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":109,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1566, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2023-02-15 17:35:45', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":102,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1567, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2023-02-15 17:35:46', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":104,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1568, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2023-02-15 17:35:47', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":100,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
INSERT INTO "public"."sys_oper_log" ("id", "operation", "business_type", "method", "create_time", "oper_name", "params", "ip") VALUES (1569, '列表查询', 'LIST', 'tech.niua.auth.controller.UserController.index', '2023-02-15 17:35:48', 'admin', '[{"id":null,"username":"","password":null,"available":null,"sexType":null,"avatar":null,"email":null,"tel":null,"deptId":111,"dept":null,"createTime":null,"updateTime":null,"roles":null,"rolesIdList":null,"newPassword":null,"roleId":null},1,10]', '127.0.0.1');
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS "public"."sys_user";
CREATE TABLE "public"."sys_user" (
  "id" int8 NOT NULL,
  "create_time" timestamp(6),
  "password" varchar(255) COLLATE "pg_catalog"."default",
  "update_time" timestamp(6),
  "username" varchar(255) COLLATE "pg_catalog"."default",
  "avatar" varchar(255) COLLATE "pg_catalog"."default",
  "available" int4,
  "email" varchar(255) COLLATE "pg_catalog"."default",
  "tel" varchar(255) COLLATE "pg_catalog"."default",
  "sex_type" int4,
  "dept_id" int8,
  "delete_flag" int4,
  "nick_name" varchar(80) COLLATE "pg_catalog"."default",
  "introduction" varchar(255) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."sys_user" OWNER TO "postgres";
COMMENT ON COLUMN "public"."sys_user"."avatar" IS '头像';
COMMENT ON COLUMN "public"."sys_user"."available" IS '是否可用：0可用，1不可用';
COMMENT ON COLUMN "public"."sys_user"."sex_type" IS '性别(0.男,1.女)';
COMMENT ON COLUMN "public"."sys_user"."dept_id" IS '部门id';
COMMENT ON COLUMN "public"."sys_user"."delete_flag" IS '是否删除：0未删除，1已删除';
COMMENT ON COLUMN "public"."sys_user"."nick_name" IS '昵称';
COMMENT ON COLUMN "public"."sys_user"."introduction" IS '介绍';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO "public"."sys_user" ("id", "create_time", "password", "update_time", "username", "avatar", "available", "email", "tel", "sex_type", "dept_id", "delete_flag", "nick_name", "introduction") VALUES (1, '2017-07-11 17:42:18', '123456', '2022-08-12 16:16:36', 'admin', 'http://127.0.0.1:9527/profile/upload/2022/08/12/159b5e03-d578-4ac2-9017-cc22899ecb01.jpg', 1, '119115556@qq.com', '15030103078', 1, 102, 0, '墨爱', NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_article_category
-- ----------------------------
DROP TABLE IF EXISTS "public"."t_article_category";
CREATE TABLE "public"."t_article_category" (
  "id" int4 NOT NULL DEFAULT nextval('t_article_category_id_seq'::regclass),
  "code" varchar(80) COLLATE "pg_catalog"."default",
  "name" varchar(255) COLLATE "pg_catalog"."default",
  "del_flag" bool,
  "create_time" timestamp(6),
  "update_time" timestamp(6)
)
;
ALTER TABLE "public"."t_article_category" OWNER TO "postgres";

-- ----------------------------
-- Records of t_article_category
-- ----------------------------
BEGIN;
INSERT INTO "public"."t_article_category" ("id", "code", "name", "del_flag", "create_time", "update_time") VALUES (1, 'tuesdays', 'tuesdays with Morrie', NULL, '2023-12-27 16:11:38.730903', '2023-12-27 16:19:04.751852');
COMMIT;

-- ----------------------------
-- Table structure for t_content
-- ----------------------------
DROP TABLE IF EXISTS "public"."t_content";
CREATE TABLE "public"."t_content" (
  "id" int4 NOT NULL DEFAULT nextval('t_content_id_seq'::regclass),
  "title" varchar(80) COLLATE "pg_catalog"."default",
  "author" varchar(80) COLLATE "pg_catalog"."default",
  "content" text COLLATE "pg_catalog"."default",
  "create_time" timestamp(6),
  "update_time" timestamp(6),
  "category_code" varchar(255) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."t_content" OWNER TO "postgres";
COMMENT ON COLUMN "public"."t_content"."category_code" IS '文章分类编码';

-- ----------------------------
-- Records of t_content
-- ----------------------------
BEGIN;
INSERT INTO "public"."t_content" ("id", "title", "author", "content", "create_time", "update_time", "category_code") VALUES (1, '用Python开发一套简单的博客系统！', '墨爱', '<p style="text-align: justify;">初版，两个月开发完成吧，预计完成时间1月30号，然后在逐渐完善，替换掉目前wordpress站点！小小的期待下:)</p>', '2023-12-10 19:09:15', '2023-12-14 23:17:46.213818', NULL);
INSERT INTO "public"."t_content" ("id", "title", "author", "content", "create_time", "update_time", "category_code") VALUES (2, '博客功能规划', '墨爱', '<p><span style="color: rgb(0, 0, 0);">目前先给这个博客系统起名为niua-blog，后期想起来更好的就在调整。</span></p><p><span style="color: rgb(0, 0, 0);">一期规划功能：</span></p><p><span style="color: rgb(0, 0, 0);">1、前端Blog的展示和预览</span></p><p><span style="color: rgb(0, 0, 0);">2、后台登录验证</span></p><p><span style="color: rgb(0, 0, 0);">3、后台Blog的文章管理</span></p><p><span style="color: rgb(0, 0, 0);">二期规划功能：</span></p><p><span style="color: rgb(0, 0, 0);">1、文章分类的支持</span></p><p><span style="color: rgb(0, 0, 0);">2、markdown语法的支持</span></p><p><span style="color: rgb(0, 0, 0);">3、文章图片和附件上传支持</span></p><p><span style="color: rgb(0, 0, 0);">4、分类导航支持</span></p><p><span style="color: rgb(0, 0, 0);">5、评论支持</span></p><p><span style="color: rgb(0, 0, 0);">6、seo支持</span></p><p><span style="color: rgb(0, 0, 0);">7、文章标签支持</span></p>', '2023-12-10 19:22:31', '2023-12-14 22:44:20.699264', NULL);
INSERT INTO "public"."t_content" ("id", "title", "author", "content", "create_time", "update_time", "category_code") VALUES (3, '开源发布地址', '墨爱', '<p>点击这里吆，&nbsp;<a href="https://gitee.com/wilson2016/niua-blog" target="_blank">这里</a></p>', '2023-12-14 22:46:11.665823', '2023-12-14 22:46:11.665814', NULL);
INSERT INTO "public"."t_content" ("id", "title", "author", "content", "create_time", "update_time", "category_code") VALUES (4, 'postgresql重启命令', '墨爱', '<pre><code >sudo service postgresql restart</code></pre><p><br></p>', '2023-12-14 22:54:39.730144', '2023-12-14 22:54:39.730137', NULL);
INSERT INTO "public"."t_content" ("id", "title", "author", "content", "create_time", "update_time", "category_code") VALUES (5, '站点正式切换为 python 版本啦!', '墨爱', '<p>站点正式切换为&nbsp;python&nbsp;版本啦！，但是目前不要正式应用在生产环境，当然，有一定技术能力的可以尝试下，也可以多提意见呦😄</p>', '2023-12-14 23:03:56.935707', '2023-12-14 23:12:27.233809', NULL);
INSERT INTO "public"."t_content" ("id", "title", "author", "content", "create_time", "update_time", "category_code") VALUES (6, '计划下一步更新内容', '墨爱', '<ol><li>&nbsp;进一步完善文章新增功能；</li><li>新增图片和文件上传功能</li></ol>', '2023-12-14 23:31:38.845051', '2023-12-14 23:31:38.845044', NULL);
INSERT INTO "public"."t_content" ("id", "title", "author", "content", "create_time", "update_time", "category_code") VALUES (7, '吐槽～服务器被攻击了无数次', '墨爱', '<p>买了一个腾讯云服务器，被勒索攻击了无数次，现在的网络安全形式真的非常差，做了一些措施，现在终于不报警了，后面还会不会被攻击，接着观察吧，所以服务器一定要做好备份，敏感数据，一定要做好防护，必要时，要购买相关安全服务👻</p>', '2023-12-14 23:35:49.544064', '2023-12-16 00:05:27.62494', NULL);
INSERT INTO "public"."t_content" ("id", "title", "author", "content", "create_time", "update_time", "category_code") VALUES (8, '上线！富文本编辑器图片上传功能', '墨爱', '<p>上传几张自己喜欢的动漫图片，猜猜你认识几个～</p><p><img src="https://www.niua.tech/imgs/assets/tmpqgy_ykdh.jpeg" alt="tmpqgy_ykdh.jpeg" data-href="" style=""/></p><p><img src="https://www.niua.tech/imgs/assets/tmpabeykhbe.jpeg" alt="tmpabeykhbe.jpeg" data-href="" style=""/></p><p><br></p><p><img src="https://www.niua.tech/imgs/assets/tmp4g1k10su.jpeg" alt="tmp4g1k10su.jpeg" data-href="" style=""/></p><p><br></p><p><img src="https://www.niua.tech/imgs/assets/tmpl8m42p0h.jpeg" alt="tmpl8m42p0h.jpeg" data-href="" style=""/></p>', '2023-12-16 00:09:36.71472', '2023-12-16 12:07:30.099084', NULL);
INSERT INTO "public"."t_content" ("id", "title", "author", "content", "create_time", "update_time", "category_code") VALUES (9, 'niua-blog 的nginx前台页面 nginx 配置', '墨爱', '<p>nginx&nbsp;的整体配置，包含&nbsp;ssl</p><pre><code >server {
     #SSL 默认访问端口号为 443
     listen 443 ssl; 
     #请填写绑定证书的域名
     server_name www.niua.tech; 
     #请填写证书文件的相对路径或绝对路径
     ssl_certificate /niua/ssl/niua.tech_bundle.crt; 
     #请填写私钥文件的相对路径或绝对路径
     ssl_certificate_key /niua/ssl/niua.tech.key; 
     ssl_session_timeout 5m;
     #请按照以下协议配置
     ssl_protocols TLSv1.2 TLSv1.3; 
     #请按照以下套件配置，配置加密套件，写法遵循 openssl 标准。
     ssl_ciphers ECDHE-RSA-AES128-GCM-SHA256:HIGH:!aNULL:!MD5:!RC4:!DHE; 
     ssl_prefer_server_ciphers on;

     location / {
         root /niua/front-ui; 
         try_files $uri $uri/ /index.html;
         index  index.html index.htm;
     }

     location /api/ {
			proxy_set_header Host $http_host;
			proxy_set_header X-Real-IP $remote_addr;
			proxy_set_header REMOTE-HOST $remote_addr;
			proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
			proxy_pass http://localhost:8081/;
	}
     location /imgs/ {            #转发或处理
        alias /niua/upload/;
    }
 }

 server {
  listen 80;
  #请填写绑定证书的域名
  server_name www.niua.tech; 
  #把http的域名请求转成https
  return 301 https://$host$request_uri; 
}
</code></pre><p><br></p><p>后台接口代理配置：</p><p><br></p><pre><code >location /api/ {
			proxy_set_header Host $http_host;
			proxy_set_header X-Real-IP $remote_addr;
			proxy_set_header REMOTE-HOST $remote_addr;
			proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
			proxy_pass http://localhost:8081/;
	}
</code></pre><p><br></p><p>图片代理访问配置：</p><p><br></p><pre><code >location /imgs/ {            #转发或处理
        alias /niua/upload/;
    }
</code></pre><p><br></p><p>避免刷新&nbsp;404</p><p><br></p><pre><code >location / {
         root /niua/front-ui; 
         try_files $uri $uri/ /index.html;
         index  index.html index.htm;
     }
</code></pre><p><br></p><p><br></p><p>避免nginx&nbsp;访问出现&nbsp;403&nbsp;的问题，需要修改nginx.conf文件的&nbsp;user&nbsp;属性，最好设置为与后台启动用户保持一致。</p>', '2023-12-16 19:33:04.314849', '2023-12-16 19:37:45.592563', NULL);
INSERT INTO "public"."t_content" ("id", "title", "author", "content", "create_time", "update_time", "category_code") VALUES (10, '下一步计划更新内容', '墨爱', '<div data-w-e-type="todo"><input type="checkbox" disabled >调整博客文章格式显示</div><div data-w-e-type="todo"><input type="checkbox" disabled >调整博客列表时间显示</div><div data-w-e-type="todo"><input type="checkbox" disabled >调整博客共用导航和&nbsp;icp&nbsp;备案信息展示</div><div data-w-e-type="todo"><input type="checkbox" disabled >实现博客&nbsp;title&nbsp;和&nbsp;description&nbsp;的显示和加载，保持对搜索引擎的友好</div><div data-w-e-type="todo"><input type="checkbox" disabled >实现博客分页和优化博客展示样式</div>', '2023-12-16 19:42:19.794832', '2023-12-16 19:42:19.794824', NULL);
INSERT INTO "public"."t_content" ("id", "title", "author", "content", "create_time", "update_time", "category_code") VALUES (11, '今日新增内容', '墨爱', '<div data-w-e-type="todo" style="text-indent: 0px; text-align: justify;"><input type="checkbox" disabled="" checked="">调整博客文章格式显示</div><div data-w-e-type="todo" style="text-indent: 0px; text-align: justify;"><input type="checkbox" disabled="" checked="">调整博客列表时间显示</div><div data-w-e-type="todo" style="text-indent: 0px; text-align: justify;"><input type="checkbox" disabled="" checked="">调整博客共用导航和&nbsp;icp&nbsp;备案信息展示</div><div data-w-e-type="todo" style="text-indent: 0px; text-align: justify;"><input type="checkbox" disabled="" checked="">优化博客展示样式</div>', '2023-12-16 23:50:15.064437', '2023-12-16 23:50:15.064431', NULL);
INSERT INTO "public"."t_content" ("id", "title", "author", "content", "create_time", "update_time", "category_code") VALUES (12, 'BUG!备案信息显示问题', '墨爱', '<p>BUG!备案信息显示问题</p><p><br></p><p><img src="https://www.niua.tech/imgs/assets/tmpgbhkay9x.png" alt="tmpgbhkay9x.png" data-href="" style=""/></p>', '2023-12-16 23:52:52.805026', '2023-12-16 23:52:52.805018', NULL);
INSERT INTO "public"."t_content" ("id", "title", "author", "content", "create_time", "update_time", "category_code") VALUES (13, 'trest', 'test', '<p>test</p>', '2023-12-20 14:42:21.237151', '2023-12-20 14:42:21.237146', NULL);
INSERT INTO "public"."t_content" ("id", "title", "author", "content", "create_time", "update_time", "category_code") VALUES (14, 'trest', 'test', '<p>test</p>', '2023-12-20 14:42:21.406484', '2023-12-20 14:42:21.406479', NULL);
INSERT INTO "public"."t_content" ("id", "title", "author", "content", "create_time", "update_time", "category_code") VALUES (15, 'test', '墨爱', '', '2024-01-14 16:13:42.428175', '2024-01-14 16:13:42.428169', NULL);
INSERT INTO "public"."t_content" ("id", "title", "author", "content", "create_time", "update_time", "category_code") VALUES (18, '444', '墨爱', '<p>444</p>', '2024-01-14 16:19:08.612656', '2024-01-14 16:19:08.612651', NULL);
INSERT INTO "public"."t_content" ("id", "title", "author", "content", "create_time", "update_time", "category_code") VALUES (16, 'qqq', '墨爱', '<p>qqqq3333</p>', '2024-01-14 16:16:09.955119', '2024-01-14 16:17:50.453685', NULL);
INSERT INTO "public"."t_content" ("id", "title", "author", "content", "create_time", "update_time", "category_code") VALUES (17, '111', '墨爱', '<p>1111</p>', '2024-01-14 16:19:00.610523', '2024-01-14 16:19:00.610517', NULL);
INSERT INTO "public"."t_content" ("id", "title", "author", "content", "create_time", "update_time", "category_code") VALUES (19, '1111', '墨爱', '<p>无聊啊</p><p><br></p><p><br></p><p><br></p><p><br></p><p><img src=""></p>', '2024-01-14 16:23:17.219891', '2024-01-19 10:55:37.592254', NULL);
INSERT INTO "public"."t_content" ("id", "title", "author", "content", "create_time", "update_time", "category_code") VALUES (20, '1111', '墨爱', '<p>11111</p>', '2024-01-19 11:09:20.03411', '2024-01-19 14:47:33.098278', 'tuesdays');
INSERT INTO "public"."t_content" ("id", "title", "author", "content", "create_time", "update_time", "category_code") VALUES (21, 'test', '墨爱', '<p>test</p>', '2024-01-19 14:47:55.64835', '2024-01-19 14:47:55.648345', 'tuesdays');
COMMIT;

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."t_article_category_id_seq"
OWNED BY "public"."t_article_category"."id";
SELECT setval('"public"."t_article_category_id_seq"', 1, true);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."t_content_id_seq"
OWNED BY "public"."t_content"."id";
SELECT setval('"public"."t_content_id_seq"', 21, true);

-- ----------------------------
-- Primary Key structure for table sys_oper_log
-- ----------------------------
ALTER TABLE "public"."sys_oper_log" ADD CONSTRAINT "sys_oper_log_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Primary Key structure for table t_article_category
-- ----------------------------
ALTER TABLE "public"."t_article_category" ADD CONSTRAINT "t_article_category_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Primary Key structure for table t_content
-- ----------------------------
ALTER TABLE "public"."t_content" ADD CONSTRAINT "t_content_pkey" PRIMARY KEY ("id");
